-
Re: Counting Blank Cells
Hi Brittanyy, Please try the following formula, ‘Status blank’ is the range you are referring to from the other sheet, and “” is for finding all the blank cells in the range. =COUNTIF({Status Blank},…1 · -
Re: Nominate Peak Humans & get a badge!
This is a fantastic opportunity to recognize outstanding contributions! 🌟 I want to nominate @Amit Wadhwani for his incredible ideas and suggestions that consistently keep me motivated. Additionall…3 · -
Re: First Day of the Prior Month and Last Day of Current Month
Hi cghallo_UCDenver, You can try this formula for the first day of the prior month- =DATE(YEAR([Shift Date]@row), MONTH([Shift Date]@row) - 1, 1) And for the last day of the current month- =IFERROR(D…1 · -
Re: August Question of the Month 💭 Join the conversation and receive a badge!
Hello Everyone, I'm Kaveri, and I'm based in India. I was introduced to Smartsheet by my seniors, and now I'm heading several projects within my company. During my initial days, I extensively explore…4 · -
Re: IF CONTAINS Help!
Hi Lisa B 2022, You can try this formula for your condition- =IF(CONTAINS("Advertising", Activity@row), 45, IF(CONTAINS("Operations", Activity@row), 30, ""))1 ·